global root "C:\Users\chupilkm\EBRD\OCE - Maxim\War data\Earthquakes replication"


clear
use "$root\Data\Working data\earthquake_gdppc_dataset.dta"


preserve
keep if iso_code == "TUR" & earthquake_start == 1999
keep growth* comp*
export excel using "$root\Charts in excel\Figure 2.xlsx", sheet("Turkiye") sheetmodify cell(B3)
restore

preserve
keep if iso_code == "HTI" & earthquake_start == 2010
keep growth* comp*
export excel using "$root\Charts in excel\Figure 2.xlsx", sheet("Haiti") sheetmodify cell(B3)
restore


preserve
keep if iso_code == "JPN" & earthquake_start == 2011
keep growth* comp*
export excel using "$root\Charts in excel\Figure 2.xlsx", sheet("Japan") sheetmodify cell(B3)
restore
